Project Request List
This article provides all the fields available for each View currently available under the Project Request List Data Source in Upland Analytics.
The following Views are available from the Project List Data Source. Click on any of them to view the available fields.
Project
| Field Name | Description | Type |
| Business Priority | This is the project business priority. | A |
| Category | This is the project category. | A |
| Category Sort Order | This is the project category sort order. | A |
| Created By | Project creator ID. | A |
| Created Date | The date the Project was created, formatted as mm/dd/yyyy with a timestamp. |
|
| Created Date Date | The date the Project was created, formatted as mm/dd/yyyy without a timestamp. |
|
| Created Date Month Year | The month and the year the Project was created. |
|
| Created Date Quarter Year | The fiscal quarter and the year the Project was created. |
|
| Created Date Year | The year the Project was created. |
|
| Created Date Week | The week the Project was created. |
|
| Description | This is the project description. | A |
| Last Status Update | This is the date and time of the project's last status update. |
|
| Modified By | This is the project modifier. | A |
| Modified Date | The date the Project was last modified, formatted as mm/dd/yyyy with a timestamp. |
|
| Modified Date Date | The date the Project was last modified, formatted as mm/dd/yyyy without a timestamp. |
|
| Modified Date Month Year | The month and the year the Project was last modified. |
|
| Modified Date Quarter Year | The fiscal quarter and the year the Project was last modified. |
|
| Modified Date Year | The year the Project was last modified. |
|
| Modified Date Week | The week the Project was last modified. |
|
| Name (Text) | This is the project name. | A |
| Name (URL) | This is the project name. It links directly to the project summary page. | A |
| Number | This is the project number. | A |
| Operations | This is the project operation. | A |
| Organization Owner | This is the project organization owner. | A |
| Owner Id | This is the Id of the owner. | A |
| Portfolio | This is the name of the portfolio associated to the project. | A |
| Priority | This is the project priority. | A |
| Priority Sort Order | This is the project priority sort order. | A |
| Program | This is the name of the program. | A |
| Project Id | This is the ID number of the project. | A |
| Project Status Id | This is the ID number of the project's current status. | |
| Status | This is the current project status. | |
| Status Id | This is the ID number of the project's current status. | A |
| Status Sort Order | This is the where the project's current status is listed in the status sort order. | A |
| Status Type | This is the project status type. | A |
| Status Type Id | This is the ID number of the project's status type. | A |
| Status Update | This is the project's most recent status update. Note that this could take up a lot of space in the report. | A |
| Type | This is the project's type. | A |
Project Request
| Field Name | Description | Type |
| Is Converted to Project | Indicates whether the Project Request has been converted into a Project or not. | A |
| Project Id | The ID number of the Project. Note: Requested Projects that have not been converted to Projects yet will not have ID numbers. |
A |
| Project Template Id | The ID number of the Project Template used to request the Project. | A |
| Project Template Name | The name of the Project Template used to request the Project. | A |
| Request Id | The ID number of the Project Request. Note: This will still be displayed for Projects that have been converted from a Project Request. |
A |
| Name (Text) | The name of the Project / Project Request. | A |
| Name (URL) | The name of the Project / Project Request. Selecting the name will navigate the report viewer to the Project Home page. Note: Only Project Requests that have been converted to Projects will contain links in this field. Project Requests do not have Home pages. |
A |
| Resolved By Full Name [First Last] | The first and last name (in that order) of the Eclipse PPM user who approved the Project Request and converted it into a Project. | A |
| Resolved By Full Name [First Last] (URL) | The first and last name (in that order) of the Eclipse PPM user who approved the Project Request and converted it into a Project. Selecting the name will navigate the report viewer to the user's profile. | A |
| Resolved By Full Name [Last First ] | The last and first name (in that order) of the Eclipse PPM user who approved the Project Request and converted it into a Project. | A |
| Resolved By Full Name [Last First ] (URL) | The last and first name (in that order) of the Eclipse PPM user who approved the Project Request and converted it into a Project. Selecting the name will navigate the report viewer to the user's profile. | A |
| Resolved Date | The date (mm/dd/yyyy) and the time the Project Request was approved and converted into a Project. |
|
| Resolved Date Month | The month the Project Request was approved and converted into a Project. |
|
| Resolved Date Month Year | The month and the year that the Project Request was approved and converted into a Project. |
|
| Resolved Date Quarter | The fiscal quarter that the Project Request was approved and converted into a Project. |
|
| Resolved Date Quarter Year | The fiscal quarter and the year that the Project Request was approved and converted into a Project. |
|
| Resolved Date Year | The year the Project Request was approved and converted into a Project. |
|
| Status | The approval status of the Project Request. | A |
| Submitted By Full Name [First Last] | The first and last name (in that order) of the Eclipse PPM user who submitted the Project Request. | A |
| Submitted By Full Name [First Last] (URL) |
The first and last name (in that order) of the Eclipse PPM user who submitted the Project Request. Selecting the name will navigate the report viewer to the user's profile. |
A |
| Submitted By Full Name [Last First ] | The last and first name (in that order) of the Eclipse PPM user who submitted the Project Request. | A |
| Submitted By Full Name [Last First ] (URL) | The last and first name (in that order) of the Eclipse PPM user who submitted the Project Request. Selecting the name will navigate the report viewer to the user's profile. | A |
| Submitted Date | The date (mm/dd/yyyy) and the time the Project Request was submitted. |
|
| Submitted Date Month | The month the Project Request was submitted. |
|
| Submitted Date Month Year | The month and the year that the Project Request was submitted. |
|
| Submitted Date Quarter | The fiscal quarter that the Project Request was submitted. |
|
| Submitted Date Quarter Year | The fiscal quarter and the year that the Project Request was submitted. |
|
| Submitted Date Year | The year the Project Request was submitted. |
|